package com.dingding.manager.modules.system.sql;

/**
 * 
* @Description: 车辆品牌SQL语句
* @author haoxiaojun 
* @date 2016年12月9日 下午6:10:01
* @since V 2.5.7
 */
public class CarTypeSQL {
	
	/**
	 * 查询所有车品牌
	 */
	public static final String GET_ALL_CAR_BRAND = "SELECT id, name, bfirstletter FROM carbrandinfo ORDER BY bfirstletter";
	
	/**
	 * 根据CarBrand的Id获取CarModel列表
	 */
	public static final String GET_CAR_MODEL_BY_ID = "SELECT b.name, b.id FROM carbrandinfo a LEFT JOIN carmodelinfo b ON a.id = b.brandId WHERE 1 = 1 ";
	
	/**
	 * 根据关键字查找车辆品牌
	 */
	public static final String GET_CAR_VRAND_BY_KEYS = "SELECT id, name, bfirstletter FROM carbrandinfo WHERE 1 = 1 ";
}
